Setting advanced connection properties

In the Advanced tab, you can set the following parameters:

• gpfdist max row length: Select or type the maximum length of a row (number of characters) in the CSV file that is sent to the gpfdist program. This is the maximum row length read by gpfdist. The default value is 32,768. The larger the size of the rows the more resources the gpfdist program uses.
• Create tables in tablespace: Type the name of the tablespace where you want create the target tables. This is optional. Note that the tablespace that you enter must exist in the Pivotal Greenplum database.
• Max file size (KB): Select or type the maximum size (in KB) of a CSV file before the file is moved into the load folder. The default value is 32000 KB.
• Write buffer size: (KB): Select or type the maximum amount of memory (in Kilobytes) used to store the data before moving it to the load folder. The default value is 1001.
• ODBC driver: Type the name of the ODBC driver you are using to connect to the Pivotal Greenplum database you are working with. The default value is DataDirect 7.0 Pivotal Greenplum Wire Protocol.
• Additional ODBC connection properties: Type any additional ODBC connection properties if required
• Use externally managed gpfdist: Select this check box to use an external gpfdist with this Pivotal Greenplum database.
• Storage folder: Type the name and location (enter full path) of the folder that holds the CSV files for loading. This is available only if you are using an externally managed gpfdist.

Internal parameters

Internal parameters are parameters that are not exposed in the UI. You should only use them if instructed by Qlik Support.

To add internal Qlik Replicate parameters:

1. Click the Internal Parameters link.

   The Internal Parameters dialog box opens.

2. In the edit box, type the name of the parameter you need to add and then click it.
3. The parameter is added to the table below the search box with its default value.
4. Change the default value as required.
5. To reset the parameter value to its default, click the "Restore default value" icon at the end of the row.

More options

These options are not exposed in the UI as they are only relevant to specific versions or environments. Consequently, do not set these options unless explicitly instructed to do so by Qlik Support or product documentation.

To set an option, simply copy the option into the Add feature name field and click Add. Then set the value or enable the option according to the instructions you received.

Settings summary

You can view a summary of your settings by clicking the Setting Summary link. This is useful if you need to send a summary of your settings to Qlik Support.